Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

View
1) A CREATE VIEW statement that uses TOP and ORDER BY clauses
2) A script that creates a stored procedure as a filter-view
3) A SELECT statement that uses the BankersMin view with where clause
4) A view is a SELECT statement thats stored with the database
5) Create a view based on correlated subquery and then query it
6) Create a view to wrap a long sql statement
7) Create a view with outer join and full join
8) Create and query a view
9) Create the view that combines all sales tables with union
10) Creating an Indexed View (CLUSTERED, NONCLUSTERED)
11) DELETE and insert from a view
12) Drop a view if it exists
13) Encrypting aView
14) Insert into a not-updatable view
15) Insert into a view
16) Join syscomments and sysobjects to query a view
17) Modifying One Column at a Time through a View
18) Query a view with where and order by
19) Setting Permissions on a View
20) Supplying Column Names in the Header of the View
21) The ALTER statement is issued with the revised view definition
22) The attempted insert or update failed
23) The syntax of the ALTER VIEW statement
24) The syntax of the CREATE VIEW statement
25) The syntax of the DROP VIEW statement
26) Use view to join four tables
27) Using the DROP statement wipes the slate clean, and reinitializes properties and security permissions
28) Using the ORDER BY Clause in a View with TOP 100 PERCENT
29) VIEWS ARE STORED named SELECT statements
30) View creation syntax
31) View with check option
32) Views have a couple of limitations
33) WITH CHECK OPTION
34) WITH SCHEMABINDING clause protects a view by binding it to the database structure, or schema